USE mseauth;

CREATE TABLE `realmlist` (
  `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(32) NOT NULL DEFAULT '',
  `Address` varchar(255) NOT NULL DEFAULT '127.0.0.1',
  `LocalAddress` varchar(255) NOT NULL DEFAULT '127.0.0.1',
  `LocalSubnetMask` varchar(255) NOT NULL DEFAULT '255.255.255.0',
  `Port` smallint(5) unsigned NOT NULL DEFAULT '0',
  `Icon` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `Timezone` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `Population` float unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  UNIQUE KEY `Idx_Name` (`Name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Realm System';